How to create a drill-through column

By linking two report columns in different reports it is possible to allow drill through from one report to another.

A typical example of this might be drill through from a summary report to a detail report showing the line items of an order after clicking on the order total in the original report.

Step by step

1. From the summary report Configure tab, locate the column which can be used to identify a detail record in the linked report. For example, the Order ID in a summary report.

2. Click the link icon, in the far right column.

3. Select the report to link to.

4. Select the column to filter by the value in the cell in the source report - usually it will be the same column as the source report.

5. Click Save.

comments powered by Disqus